package com.crm.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.time.LocalDate;

@Mapper
public interface ContractMapper {
    @Select("select count(id)from tb_contract where date(create_time) between #{beginCreateTime} and #{endCreateTime} and business_id is not null")
    Integer countBybusiness(LocalDate beginCreateTime, LocalDate endCreateTime);
}
